Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	8950
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.2 MiB
Average record size in memory	136.0 B

Variable types

Numeric	17

Alerts

`BALANCE` is highly overall correlated with `BALANCE_FREQUENCY` and 4 other fields	High correlation
`BALANCE_FREQUENCY` is highly overall correlated with `BALANCE`	High correlation
`PURCHASES` is highly overall correlated with `ONEOFF_PURCHASES` and 5 other fields	High correlation
`ONEOFF_PURCHASES` is highly overall correlated with `PURCHASES` and 2 other fields	High correlation
`INSTALLMENTS_PURCHASES` is highly overall correlated with `PURCHASES` and 3 other fields	High correlation
`CASH_ADVANCE` is highly overall correlated with `BALANCE` and 2 other fields	High correlation
`PURCHASES_FREQUENCY` is highly overall correlated with `PURCHASES` and 3 other fields	High correlation
`ONEOFF_PURCHASES_FREQUENCY` is highly overall correlated with `PURCHASES` and 2 other fields	High correlation
`PURCHASES_INSTALLMENTS_FREQUENCY` is highly overall correlated with `PURCHASES` and 3 other fields	High correlation
`CASH_ADVANCE_FREQUENCY` is highly overall correlated with `BALANCE` and 2 other fields	High correlation
`CASH_ADVANCE_TRX` is highly overall correlated with `BALANCE` and 2 other fields	High correlation
`PURCHASES_TRX` is highly overall correlated with `PURCHASES` and 5 other fields	High correlation
`MINIMUM_PAYMENTS_NEW` is highly overall correlated with `BALANCE`	High correlation
`PURCHASES` has 2044 (22.8%) zeros	Zeros
`ONEOFF_PURCHASES` has 4302 (48.1%) zeros	Zeros
`INSTALLMENTS_PURCHASES` has 3916 (43.8%) zeros	Zeros
`CASH_ADVANCE` has 4628 (51.7%) zeros	Zeros
`PURCHASES_FREQUENCY` has 2043 (22.8%) zeros	Zeros
`ONEOFF_PURCHASES_FREQUENCY` has 4302 (48.1%) zeros	Zeros
`PURCHASES_INSTALLMENTS_FREQUENCY` has 3915 (43.7%) zeros	Zeros
`CASH_ADVANCE_FREQUENCY` has 4628 (51.7%) zeros	Zeros
`CASH_ADVANCE_TRX` has 4628 (51.7%) zeros	Zeros
`PURCHASES_TRX` has 2044 (22.8%) zeros	Zeros
`PAYMENTS` has 240 (2.7%) zeros	Zeros
`PRC_FULL_PAYMENT` has 5903 (66.0%) zeros	Zeros

Reproduction

Analysis started	2023-12-02 10:19:51.797948
Analysis finished	2023-12-02 10:21:17.593846
Duration	1 minute and 25.8 seconds
Software version	pandas-profiling vv3.6.3
Download configuration	config.json

BALANCE
Real number (ℝ)

Distinct	8871
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1564.4748

Minimum	0
Maximum	19043.139
Zeros	80
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	8.8145184
Q1	128.28192
median	873.38523
Q3	2054.14
95-th percentile	5909.1118
Maximum	19043.139
Range	19043.139
Interquartile range (IQR)	1925.8581

Descriptive statistics

Standard deviation	2081.5319
Coefficient of variation (CV)	1.3304988
Kurtosis	7.6747513
Mean	1564.4748
Median Absolute Deviation (MAD)	799.8652
Skewness	2.393386
Sum	14002050
Variance	4332775
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	80	0.9%
40.900749	1	< 0.1%
1213.551338	1	< 0.1%
1253.188317	1	< 0.1%
5058.299635	1	< 0.1%
296.905944	1	< 0.1%
1084.652647	1	< 0.1%
237.198442	1	< 0.1%
1636.518315	1	< 0.1%
468.851415	1	< 0.1%
Other values (8861)	8861	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	80	0.9%
0.000199	1	< 0.1%
0.001146	1	< 0.1%
0.001214	1	< 0.1%
0.001289	1	< 0.1%
0.004816	1	< 0.1%
0.006651	1	< 0.1%
0.009684	1	< 0.1%
0.01968	1	< 0.1%
0.021102	1	< 0.1%

Value	Count	Frequency (%)
19043.13856	1	< 0.1%
18495.55855	1	< 0.1%
16304.88925	1	< 0.1%
16259.44857	1	< 0.1%
16115.5964	1	< 0.1%
15532.33972	1	< 0.1%
15258.2259	1	< 0.1%
15244.74865	1	< 0.1%
15155.53286	1	< 0.1%
14581.45914	1	< 0.1%

BALANCE_FREQUENCY
Real number (ℝ)

Distinct	43
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.87727073

Minimum	0
Maximum	1
Zeros	80
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.272727
Q1	0.888889
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.111111

Descriptive statistics

Standard deviation	0.236904
Coefficient of variation (CV)	0.27004663
Kurtosis	3.0923696
Mean	0.87727073
Median Absolute Deviation (MAD)	0
Skewness	-2.0232655
Sum	7851.573
Variance	0.056123506
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
1	6211	69.4%
0.909091	410	4.6%
0.818182	278	3.1%
0.727273	223	2.5%
0.545455	219	2.4%
0.636364	209	2.3%
0.454545	172	1.9%
0.363636	170	1.9%
0.272727	151	1.7%
0.181818	146	1.6%
Other values (33)	761	8.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	80	0.9%
0.090909	67	0.7%
0.1	8	0.1%
0.111111	5	0.1%
0.125	9	0.1%
0.142857	7	0.1%
0.166667	7	0.1%
0.181818	146	1.6%
0.2	9	0.1%
0.222222	5	0.1%

Value	Count	Frequency (%)
1	6211	69.4%
0.909091	410	4.6%
0.9	55	0.6%
0.888889	53	0.6%
0.875	57	0.6%
0.857143	51	0.6%
0.833333	60	0.7%
0.818182	278	3.1%
0.8	20	0.2%
0.777778	22	0.2%

PURCHASES
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	6203
Distinct (%)	69.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1003.2048

Minimum	0
Maximum	49039.57
Zeros	2044
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	39.635
median	361.28
Q3	1110.13
95-th percentile	3998.6195
Maximum	49039.57
Range	49039.57
Interquartile range (IQR)	1070.495

Descriptive statistics

Standard deviation	2136.6348
Coefficient of variation (CV)	2.1298091
Kurtosis	111.38877
Mean	1003.2048
Median Absolute Deviation (MAD)	361.28
Skewness	8.1442691
Sum	8978683.3
Variance	4565208.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2044	22.8%
45.65	27	0.3%
60	16	0.2%
150	16	0.2%
300	13	0.1%
200	13	0.1%
100	13	0.1%
450	12	0.1%
50	10	0.1%
600	10	0.1%
Other values (6193)	6776	75.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2044	22.8%
0.01	4	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
0.7	1	< 0.1%
1	2	< 0.1%
1.4	1	< 0.1%
2	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%

Value	Count	Frequency (%)
49039.57	1	< 0.1%
41050.4	1	< 0.1%
40040.71	1	< 0.1%
38902.71	1	< 0.1%
35131.16	1	< 0.1%
32539.78	1	< 0.1%
31299.35	1	< 0.1%
27957.68	1	< 0.1%
27790.42	1	< 0.1%
26784.62	1	< 0.1%

ONEOFF_PURCHASES
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4014
Distinct (%)	44.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	592.43737

Minimum	0
Maximum	40761.25
Zeros	4302
Zeros (%)	48.1%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	38
Q3	577.405
95-th percentile	2671.094
Maximum	40761.25
Range	40761.25
Interquartile range (IQR)	577.405

Descriptive statistics

Standard deviation	1659.8879
Coefficient of variation (CV)	2.8017948
Kurtosis	164.18757
Mean	592.43737
Median Absolute Deviation (MAD)	38
Skewness	10.045083
Sum	5302314.5
Variance	2755227.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4302	48.1%
45.65	46	0.5%
50	17	0.2%
200	15	0.2%
60	13	0.1%
100	13	0.1%
150	12	0.1%
70	12	0.1%
1000	12	0.1%
250	11	0.1%
Other values (4004)	4497	50.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4302	48.1%
0.01	7	0.1%
0.02	2	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
0.7	1	< 0.1%
1	4	< 0.1%
1.4	2	< 0.1%
2	1	< 0.1%
4.99	1	< 0.1%

Value	Count	Frequency (%)
40761.25	1	< 0.1%
40624.06	1	< 0.1%
34087.73	1	< 0.1%
33803.84	1	< 0.1%
26547.43	1	< 0.1%
26514.32	1	< 0.1%
25122.77	1	< 0.1%
24543.52	1	< 0.1%
23032.97	1	< 0.1%
22257.39	1	< 0.1%

INSTALLMENTS_PURCHASES
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4452
Distinct (%)	49.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	411.06764

Minimum	0
Maximum	22500
Zeros	3916
Zeros (%)	43.8%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	89
Q3	468.6375
95-th percentile	1750.0875
Maximum	22500
Range	22500
Interquartile range (IQR)	468.6375

Descriptive statistics

Standard deviation	904.33812
Coefficient of variation (CV)	2.199974
Kurtosis	96.575178
Mean	411.06764
Median Absolute Deviation (MAD)	89
Skewness	7.2991199
Sum	3679055.4
Variance	817827.43
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3916	43.8%
300	14	0.2%
200	14	0.2%
100	14	0.2%
150	12	0.1%
125	11	0.1%
75	9	0.1%
350	8	0.1%
450	8	0.1%
500	8	0.1%
Other values (4442)	4936	55.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3916	43.8%
1.95	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
6.33	1	< 0.1%
7.26	1	< 0.1%
7.67	1	< 0.1%
9.28	1	< 0.1%
9.58	1	< 0.1%
9.65	1	< 0.1%

Value	Count	Frequency (%)
22500	1	< 0.1%
15497.19	1	< 0.1%
14686.1	1	< 0.1%
13184.43	1	< 0.1%
12738.47	1	< 0.1%
12560.85	1	< 0.1%
12541	1	< 0.1%
12375	1	< 0.1%
12235.05	1	< 0.1%
12128.94	1	< 0.1%

CASH_ADVANCE
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4323
Distinct (%)	48.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	978.87111

Minimum	0
Maximum	47137.212
Zeros	4628
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1113.8211
95-th percentile	4647.1691
Maximum	47137.212
Range	47137.212
Interquartile range (IQR)	1113.8211

Descriptive statistics

Standard deviation	2097.1639
Coefficient of variation (CV)	2.1424311
Kurtosis	52.899434
Mean	978.87111
Median Absolute Deviation (MAD)	0
Skewness	5.1666091
Sum	8760896.5
Variance	4398096.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
495.425832	1	< 0.1%
1486.243293	1	< 0.1%
855.232779	1	< 0.1%
3767.104707	1	< 0.1%
291.608512	1	< 0.1%
38.690552	1	< 0.1%
521.664369	1	< 0.1%
1974.202963	1	< 0.1%
2462.100789	1	< 0.1%
Other values (4313)	4313	48.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4628	51.7%
14.222216	1	< 0.1%
18.042768	1	< 0.1%
18.117967	1	< 0.1%
18.123413	1	< 0.1%
18.126683	1	< 0.1%
18.149946	1	< 0.1%
18.204577	1	< 0.1%
18.240626	1	< 0.1%
18.280043	1	< 0.1%

Value	Count	Frequency (%)
47137.21176	1	< 0.1%
29282.10915	1	< 0.1%
27296.48576	1	< 0.1%
26268.69989	1	< 0.1%
26194.04954	1	< 0.1%
23130.82106	1	< 0.1%
22665.7785	1	< 0.1%
21943.84942	1	< 0.1%
20712.67008	1	< 0.1%
20277.33112	1	< 0.1%

PURCHASES_FREQUENCY
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.49035055

Minimum	0
Maximum	1
Zeros	2043
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.083333
median	0.5
Q3	0.916667
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.833334

Descriptive statistics

Standard deviation	0.40137075
Coefficient of variation (CV)	0.81853839
Kurtosis	-1.6386309
Mean	0.49035055
Median Absolute Deviation (MAD)	0.416667
Skewness	0.060164236
Sum	4388.6374
Variance	0.16109848
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	2178	24.3%
0	2043	22.8%
0.083333	677	7.6%
0.916667	396	4.4%
0.5	395	4.4%
0.166667	392	4.4%
0.833333	373	4.2%
0.333333	367	4.1%
0.25	345	3.9%
0.583333	316	3.5%
Other values (37)	1468	16.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2043	22.8%
0.083333	677	7.6%
0.090909	43	0.5%
0.1	27	0.3%
0.111111	18	0.2%
0.125	32	0.4%
0.142857	26	0.3%
0.166667	392	4.4%
0.181818	16	0.2%
0.2	19	0.2%

Value	Count	Frequency (%)
1	2178	24.3%
0.916667	396	4.4%
0.909091	28	0.3%
0.9	24	0.3%
0.888889	18	0.2%
0.875	26	0.3%
0.857143	25	0.3%
0.833333	373	4.2%
0.818182	21	0.2%
0.8	9	0.1%

ONEOFF_PURCHASES_FREQUENCY
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.20245768

Minimum	0
Maximum	1
Zeros	4302
Zeros (%)	48.1%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.083333
Q3	0.3
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.3

Descriptive statistics

Standard deviation	0.29833607
Coefficient of variation (CV)	1.4735725
Kurtosis	1.1618456
Mean	0.20245768
Median Absolute Deviation (MAD)	0.083333
Skewness	1.5356128
Sum	1811.9963
Variance	0.089004408
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	4302	48.1%
0.083333	1104	12.3%
0.166667	592	6.6%
1	481	5.4%
0.25	418	4.7%
0.333333	355	4.0%
0.416667	244	2.7%
0.5	235	2.6%
0.583333	197	2.2%
0.666667	167	1.9%
Other values (37)	855	9.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4302	48.1%
0.083333	1104	12.3%
0.090909	56	0.6%
0.1	39	0.4%
0.111111	26	0.3%
0.125	41	0.5%
0.142857	37	0.4%
0.166667	592	6.6%
0.181818	34	0.4%
0.2	27	0.3%

Value	Count	Frequency (%)
1	481	5.4%
0.916667	151	1.7%
0.909091	4	< 0.1%
0.9	1	< 0.1%
0.888889	2	< 0.1%
0.875	6	0.1%
0.857143	1	< 0.1%
0.833333	120	1.3%
0.818182	10	0.1%
0.8	4	< 0.1%

PURCHASES_INSTALLMENTS_FREQUENCY
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.36443734

Minimum	0
Maximum	1
Zeros	3915
Zeros (%)	43.7%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.166667
Q3	0.75
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.39744778
Coefficient of variation (CV)	1.0905792
Kurtosis	-1.3986322
Mean	0.36443734
Median Absolute Deviation (MAD)	0.166667
Skewness	0.50920116
Sum	3261.7142
Variance	0.15796474
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	3915	43.7%
1	1331	14.9%
0.416667	388	4.3%
0.916667	345	3.9%
0.833333	311	3.5%
0.5	310	3.5%
0.166667	305	3.4%
0.666667	292	3.3%
0.75	291	3.3%
0.083333	275	3.1%
Other values (37)	1187	13.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3915	43.7%
0.083333	275	3.1%
0.090909	12	0.1%
0.1	6	0.1%
0.111111	9	0.1%
0.125	5	0.1%
0.142857	6	0.1%
0.166667	305	3.4%
0.181818	14	0.2%
0.2	9	0.1%

Value	Count	Frequency (%)
1	1331	14.9%
0.916667	345	3.9%
0.909091	25	0.3%
0.9	19	0.2%
0.888889	28	0.3%
0.875	28	0.3%
0.857143	30	0.3%
0.833333	311	3.5%
0.818182	21	0.2%
0.8	18	0.2%

CASH_ADVANCE_FREQUENCY
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	54
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1351442

Minimum	0
Maximum	1.5
Zeros	4628
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.222222
95-th percentile	0.583333
Maximum	1.5
Range	1.5
Interquartile range (IQR)	0.222222

Descriptive statistics

Standard deviation	0.20012139
Coefficient of variation (CV)	1.4807989
Kurtosis	3.3347343
Mean	0.1351442
Median Absolute Deviation (MAD)	0
Skewness	1.8286863
Sum	1209.5406
Variance	0.04004857
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
0.083333	1021	11.4%
0.166667	759	8.5%
0.25	578	6.5%
0.333333	439	4.9%
0.416667	273	3.1%
0.5	215	2.4%
0.583333	142	1.6%
0.666667	125	1.4%
0.090909	70	0.8%
Other values (44)	700	7.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4628	51.7%
0.083333	1021	11.4%
0.090909	70	0.8%
0.1	39	0.4%
0.111111	29	0.3%
0.125	47	0.5%
0.142857	49	0.5%
0.166667	759	8.5%
0.181818	42	0.5%
0.2	21	0.2%

Value	Count	Frequency (%)
1.5	1	< 0.1%
1.25	1	< 0.1%
1.166667	2	< 0.1%
1.142857	1	< 0.1%
1.125	1	< 0.1%
1.1	1	< 0.1%
1.090909	1	< 0.1%
1	25	0.3%
0.916667	27	0.3%
0.909091	3	< 0.1%

CASH_ADVANCE_TRX
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	65
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.2488268

Minimum	0
Maximum	123
Zeros	4628
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	15
Maximum	123
Range	123
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	6.8246467
Coefficient of variation (CV)	2.1006496
Kurtosis	61.646862
Mean	3.2488268
Median Absolute Deviation (MAD)	0
Skewness	5.7212982
Sum	29077
Variance	46.575803
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
1	887	9.9%
2	620	6.9%
3	436	4.9%
4	384	4.3%
5	308	3.4%
6	246	2.7%
7	205	2.3%
8	171	1.9%
10	150	1.7%
Other values (55)	915	10.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4628	51.7%
1	887	9.9%
2	620	6.9%
3	436	4.9%
4	384	4.3%
5	308	3.4%
6	246	2.7%
7	205	2.3%
8	171	1.9%
9	111	1.2%

Value	Count	Frequency (%)
123	3	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
93	1	< 0.1%
80	1	< 0.1%
71	1	< 0.1%
69	1	< 0.1%
63	1	< 0.1%
62	3	< 0.1%
61	1	< 0.1%

PURCHASES_TRX
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	173
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.709832

Minimum	0
Maximum	358
Zeros	2044
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	7
Q3	17
95-th percentile	57
Maximum	358
Range	358
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	24.857649
Coefficient of variation (CV)	1.6898662
Kurtosis	34.7931
Mean	14.709832
Median Absolute Deviation (MAD)	7
Skewness	4.6306553
Sum	131653
Variance	617.90272
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2044	22.8%
1	667	7.5%
12	570	6.4%
2	379	4.2%
6	352	3.9%
3	314	3.5%
4	285	3.2%
7	275	3.1%
5	267	3.0%
8	267	3.0%
Other values (163)	3530	39.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2044	22.8%
1	667	7.5%
2	379	4.2%
3	314	3.5%
4	285	3.2%
5	267	3.0%
6	352	3.9%
7	275	3.1%
8	267	3.0%
9	248	2.8%

Value	Count	Frequency (%)
358	1	< 0.1%
347	1	< 0.1%
344	1	< 0.1%
309	1	< 0.1%
308	1	< 0.1%
298	1	< 0.1%
274	1	< 0.1%
273	1	< 0.1%
254	1	< 0.1%
248	2	< 0.1%

PAYMENTS
Real number (ℝ)

Distinct	8711
Distinct (%)	97.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1733.1439

Minimum	0
Maximum	50721.483
Zeros	240
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	89.988924
Q1	383.27617
median	856.90155
Q3	1901.1343
95-th percentile	6082.0906
Maximum	50721.483
Range	50721.483
Interquartile range (IQR)	1517.8582

Descriptive statistics

Standard deviation	2895.0638
Coefficient of variation (CV)	1.6704117
Kurtosis	54.770736
Mean	1733.1439
Median Absolute Deviation (MAD)	581.35146
Skewness	5.9076198
Sum	15511637
Variance	8381394.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	240	2.7%
201.802084	1	< 0.1%
398.316441	1	< 0.1%
826.036748	1	< 0.1%
2571.573214	1	< 0.1%
1903.279643	1	< 0.1%
454.888506	1	< 0.1%
956.028747	1	< 0.1%
4560.77572	1	< 0.1%
1825.349955	1	< 0.1%
Other values (8701)	8701	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	240	2.7%
0.049513	1	< 0.1%
0.056466	1	< 0.1%
2.389583	1	< 0.1%
3.500505	1	< 0.1%
4.523555	1	< 0.1%
4.841543	1	< 0.1%
5.070726	1	< 0.1%
9.040017	1	< 0.1%
9.533313	1	< 0.1%

Value	Count	Frequency (%)
50721.48336	1	< 0.1%
46930.59824	1	< 0.1%
40627.59524	1	< 0.1%
39461.9658	1	< 0.1%
39048.59762	1	< 0.1%
36066.75068	1	< 0.1%
35843.62593	1	< 0.1%
34107.07499	1	< 0.1%
33994.72785	1	< 0.1%
33486.31044	1	< 0.1%

PRC_FULL_PAYMENT
Real number (ℝ)

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.15371465

Minimum	0
Maximum	1
Zeros	5903
Zeros (%)	66.0%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.142857
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.142857

Descriptive statistics

Standard deviation	0.2924992
Coefficient of variation (CV)	1.9028713
Kurtosis	2.4323953
Mean	0.15371465
Median Absolute Deviation (MAD)	0
Skewness	1.9428199
Sum	1375.7461
Variance	0.08555578
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	5903	66.0%
1	488	5.5%
0.083333	426	4.8%
0.166667	166	1.9%
0.5	156	1.7%
0.25	156	1.7%
0.090909	153	1.7%
0.333333	134	1.5%
0.1	94	1.1%
0.2	83	0.9%
Other values (37)	1191	13.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5903	66.0%
0.083333	426	4.8%
0.090909	153	1.7%
0.1	94	1.1%
0.111111	61	0.7%
0.125	52	0.6%
0.142857	54	0.6%
0.166667	166	1.9%
0.181818	75	0.8%
0.2	83	0.9%

Value	Count	Frequency (%)
1	488	5.5%
0.916667	77	0.9%
0.909091	19	0.2%
0.9	16	0.2%
0.888889	12	0.1%
0.875	18	0.2%
0.857143	12	0.1%
0.833333	63	0.7%
0.818182	17	0.2%
0.8	33	0.4%

TENURE
Real number (ℝ)

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.517318

Minimum	6
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	6
5-th percentile	8
Q1	12
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3383308
Coefficient of variation (CV)	0.11620159
Kurtosis	7.6948232
Mean	11.517318
Median Absolute Deviation (MAD)	0
Skewness	-2.9430173
Sum	103080
Variance	1.7911292
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
12	7584	84.7%
11	365	4.1%
10	236	2.6%
6	204	2.3%
8	196	2.2%
7	190	2.1%
9	175	2.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	204	2.3%
7	190	2.1%
8	196	2.2%
9	175	2.0%
10	236	2.6%
11	365	4.1%
12	7584	84.7%

Value	Count	Frequency (%)
12	7584	84.7%
11	365	4.1%
10	236	2.6%
9	175	2.0%
8	196	2.2%
7	190	2.1%
6	204	2.3%

MINIMUM_PAYMENTS_NEW
Real number (ℝ)

Distinct	8636
Distinct (%)	96.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	844.90677

Minimum	0.019163
Maximum	76406.208
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0.019163
5-th percentile	74.644117
Q1	170.85765
median	312.34395
Q3	788.7135
95-th percentile	2719.5669
Maximum	76406.208
Range	76406.188
Interquartile range (IQR)	617.85585

Descriptive statistics

Standard deviation	2332.7923
Coefficient of variation (CV)	2.7610056
Kurtosis	293.72029
Mean	844.90677
Median Absolute Deviation (MAD)	182.69353
Skewness	13.852446
Sum	7561915.6
Variance	5441920
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
312.343947	314	3.5%
299.351881	2	< 0.1%
1600.26917	1	< 0.1%
229.411418	1	< 0.1%
271.528169	1	< 0.1%
6404.855484	1	< 0.1%
616.862544	1	< 0.1%
211.984193	1	< 0.1%
324.954747	1	< 0.1%
139.509787	1	< 0.1%
Other values (8626)	8626	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.019163	1	< 0.1%
0.037744	1	< 0.1%
0.05588	1	< 0.1%
0.059481	1	< 0.1%
0.117036	1	< 0.1%
0.261984	1	< 0.1%
0.311953	1	< 0.1%
0.319475	1	< 0.1%
1.113027	1	< 0.1%
1.334075	1	< 0.1%

Value	Count	Frequency (%)
76406.20752	1	< 0.1%
61031.6186	1	< 0.1%
56370.04117	1	< 0.1%
50260.75947	1	< 0.1%
43132.72823	1	< 0.1%
42629.55117	1	< 0.1%
38512.12477	1	< 0.1%
31871.36379	1	< 0.1%
30528.4324	1	< 0.1%
29019.80288	1	< 0.1%

CREDIT_LIMIT_NEW
Real number (ℝ)

Distinct	205
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4494.2825

Minimum	50
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	50
5-th percentile	1000
Q1	1600
median	3000
Q3	6500
95-th percentile	12000
Maximum	30000
Range	29950
Interquartile range (IQR)	4900

Descriptive statistics

Standard deviation	3638.6467
Coefficient of variation (CV)	0.80961682
Kurtosis	2.8373707
Mean	4494.2825
Median Absolute Deviation (MAD)	1800
Skewness	1.522636
Sum	40223828
Variance	13239750
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3000	785	8.8%
1500	722	8.1%
1200	621	6.9%
1000	614	6.9%
2500	612	6.8%
4000	506	5.7%
6000	463	5.2%
5000	389	4.3%
2000	371	4.1%
7500	277	3.1%
Other values (195)	3590	40.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
50	1	< 0.1%
150	5	0.1%
200	3	< 0.1%
300	14	0.2%
400	3	< 0.1%
450	6	0.1%
500	121	1.4%
600	21	0.2%
650	1	< 0.1%
700	20	0.2%

Value	Count	Frequency (%)
30000	2	< 0.1%
28000	1	< 0.1%
25000	1	< 0.1%
23000	2	< 0.1%
22500	1	< 0.1%
22000	1	< 0.1%
21500	2	< 0.1%
21000	2	< 0.1%
20500	1	< 0.1%
20000	10	0.1%

Auto

Heatmap
Table

	BALANCE	BALANCE_FREQUENCY	PURCHASES	ONEOFF_PURCHASES	INSTALLMENTS_PURCHASES	CASH_ADVANCE	PURCHASES_FREQUENCY	ONEOFF_PURCHASES_FREQUENCY	PURCHASES_INSTALLMENTS_FREQUENCY	CASH_ADVANCE_FREQUENCY	CASH_ADVANCE_TRX	PURCHASES_TRX	PAYMENTS	PRC_FULL_PAYMENT	TENURE	MINIMUM_PAYMENTS_NEW	CREDIT_LIMIT_NEW
BALANCE	1.000	0.545	0.006	0.146	-0.090	0.566	-0.145	0.120	-0.144	0.544	0.549	-0.046	0.432	-0.484	0.066	0.871	0.372
BALANCE_FREQUENCY	0.545	1.000	0.148	0.135	0.128	0.137	0.202	0.159	0.152	0.177	0.176	0.203	0.207	-0.174	0.229	0.472	0.106
PURCHASES	0.006	0.148	1.000	0.751	0.706	-0.385	0.795	0.693	0.606	-0.391	-0.384	0.885	0.395	0.238	0.133	-0.014	0.261
ONEOFF_PURCHASES	0.146	0.135	0.751	1.000	0.200	-0.185	0.424	0.952	0.117	-0.179	-0.175	0.590	0.363	0.049	0.096	0.066	0.305
INSTALLMENTS_PURCHASES	-0.090	0.128	0.706	0.200	1.000	-0.357	0.786	0.185	0.923	-0.366	-0.357	0.784	0.239	0.276	0.125	-0.056	0.123
CASH_ADVANCE	0.566	0.137	-0.385	-0.185	-0.357	1.000	-0.454	-0.189	-0.378	0.941	0.952	-0.408	0.257	-0.266	-0.113	0.476	0.163
PURCHASES_FREQUENCY	-0.145	0.202	0.795	0.424	0.786	-0.454	1.000	0.463	0.852	-0.453	-0.447	0.924	0.172	0.292	0.098	-0.107	0.104
ONEOFF_PURCHASES_FREQUENCY	0.120	0.159	0.693	0.952	0.185	-0.189	0.463	1.000	0.112	-0.176	-0.174	0.607	0.321	0.061	0.084	0.048	0.282
PURCHASES_INSTALLMENTS_FREQUENCY	-0.144	0.152	0.606	0.117	0.923	-0.378	0.852	0.112	1.000	-0.382	-0.374	0.781	0.121	0.259	0.114	-0.088	0.047
CASH_ADVANCE_FREQUENCY	0.544	0.177	-0.391	-0.179	-0.366	0.941	-0.453	-0.176	-0.382	1.000	0.983	-0.407	0.203	-0.287	-0.131	0.453	0.088
CASH_ADVANCE_TRX	0.549	0.176	-0.384	-0.175	-0.357	0.952	-0.447	-0.174	-0.374	0.983	1.000	-0.399	0.215	-0.281	-0.099	0.468	0.097
PURCHASES_TRX	-0.046	0.203	0.885	0.590	0.784	-0.408	0.924	0.607	0.781	-0.407	-0.399	1.000	0.284	0.253	0.169	-0.031	0.190
PAYMENTS	0.432	0.207	0.395	0.363	0.239	0.257	0.172	0.321	0.121	0.203	0.215	0.284	1.000	0.187	0.205	0.349	0.449
PRC_FULL_PAYMENT	-0.484	-0.174	0.238	0.049	0.276	-0.266	0.292	0.061	0.259	-0.287	-0.281	0.253	0.187	1.000	0.020	-0.477	0.021
TENURE	0.066	0.229	0.133	0.096	0.125	-0.113	0.098	0.084	0.114	-0.131	-0.099	0.169	0.205	0.020	1.000	0.130	0.170
MINIMUM_PAYMENTS_NEW	0.871	0.472	-0.014	0.066	-0.056	0.476	-0.107	0.048	-0.088	0.453	0.468	-0.031	0.349	-0.477	0.130	1.000	0.258
CREDIT_LIMIT_NEW	0.372	0.106	0.261	0.305	0.123	0.163	0.104	0.282	0.047	0.088	0.097	0.190	0.449	0.021	0.170	0.258	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	BALANCE	BALANCE_FREQUENCY	PURCHASES	ONEOFF_PURCHASES	INSTALLMENTS_PURCHASES	CASH_ADVANCE	PURCHASES_FREQUENCY	ONEOFF_PURCHASES_FREQUENCY	PURCHASES_INSTALLMENTS_FREQUENCY	CASH_ADVANCE_FREQUENCY	CASH_ADVANCE_TRX	PURCHASES_TRX	PAYMENTS	PRC_FULL_PAYMENT	TENURE	MINIMUM_PAYMENTS_NEW	CREDIT_LIMIT_NEW
0	40.900749	0.818182	95.40	0.00	95.40	0.000000	0.166667	0.000000	0.083333	0.000000	0	2	201.802084	0.000000	12	139.509787	1000.0
1	3202.467416	0.909091	0.00	0.00	0.00	6442.945483	0.000000	0.000000	0.000000	0.250000	4	0	4103.032597	0.222222	12	1072.340217	7000.0
2	2495.148862	1.000000	773.17	773.17	0.00	0.000000	1.000000	1.000000	0.000000	0.000000	0	12	622.066742	0.000000	12	627.284787	7500.0
3	1666.670542	0.636364	1499.00	1499.00	0.00	205.788017	0.083333	0.083333	0.000000	0.083333	1	1	0.000000	0.000000	12	312.343947	7500.0
4	817.714335	1.000000	16.00	16.00	0.00	0.000000	0.083333	0.083333	0.000000	0.000000	0	1	678.334763	0.000000	12	244.791237	1200.0
5	1809.828751	1.000000	1333.28	0.00	1333.28	0.000000	0.666667	0.000000	0.583333	0.000000	0	8	1400.057770	0.000000	12	2407.246035	1800.0
6	627.260806	1.000000	7091.01	6402.63	688.38	0.000000	1.000000	1.000000	1.000000	0.000000	0	64	6354.314328	1.000000	12	198.065894	13500.0
7	1823.652743	1.000000	436.20	0.00	436.20	0.000000	1.000000	0.000000	1.000000	0.000000	0	12	679.065082	0.000000	12	532.033990	2300.0
8	1014.926473	1.000000	861.49	661.49	200.00	0.000000	0.333333	0.083333	0.250000	0.000000	0	5	688.278568	0.000000	12	311.963409	7000.0
9	152.225975	0.545455	1281.60	1281.60	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	3	1164.770591	0.000000	12	100.302262	11000.0

	BALANCE	BALANCE_FREQUENCY	PURCHASES	ONEOFF_PURCHASES	INSTALLMENTS_PURCHASES	CASH_ADVANCE	PURCHASES_FREQUENCY	ONEOFF_PURCHASES_FREQUENCY	PURCHASES_INSTALLMENTS_FREQUENCY	CASH_ADVANCE_FREQUENCY	CASH_ADVANCE_TRX	PURCHASES_TRX	PAYMENTS	PRC_FULL_PAYMENT	TENURE	MINIMUM_PAYMENTS_NEW	CREDIT_LIMIT_NEW
8940	130.838554	1.000000	591.24	0.00	591.24	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	475.523262	1.00	6	82.771320	1000.0
8941	5967.475270	0.833333	214.55	0.00	214.55	8555.409326	0.833333	0.000000	0.666667	0.666667	13	5	966.202912	0.00	6	861.949906	9000.0
8942	40.829749	1.000000	113.28	0.00	113.28	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	94.488828	0.25	6	86.283101	1000.0
8943	5.871712	0.500000	20.90	20.90	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	1	58.644883	0.00	6	43.473717	500.0
8944	193.571722	0.833333	1012.73	1012.73	0.00	0.000000	0.333333	0.333333	0.000000	0.000000	0	2	0.000000	0.00	6	312.343947	4000.0
8945	28.493517	1.000000	291.12	0.00	291.12	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	325.594462	0.50	6	48.886365	1000.0
8946	19.183215	1.000000	300.00	0.00	300.00	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	275.861322	0.00	6	312.343947	1000.0
8947	23.398673	0.833333	144.40	0.00	144.40	0.000000	0.833333	0.000000	0.666667	0.000000	0	5	81.270775	0.25	6	82.418369	1000.0
8948	13.457564	0.833333	0.00	0.00	0.00	36.558778	0.000000	0.000000	0.000000	0.166667	2	0	52.549959	0.25	6	55.755628	500.0
8949	372.708075	0.666667	1093.25	1093.25	0.00	127.040008	0.666667	0.666667	0.000000	0.333333	2	23	63.165404	0.00	6	88.288956	1200.0

Overview

Variables

Interactions

Correlations

Missing values

Sample